package com.co.user.mapper;

import com.co.user.pojo.History;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;
import java.util.Map;

/**
 * @author ldl.plus
 * @date 2020年06月22日  0:41
 */
@org.apache.ibatis.annotations.Mapper
public interface HistoryMapper extends Mapper<History> {

    @Select("select aid from us_history where username=#{username} order by create_time asc")
    List<String> findHistoryByUsername(@Param("username")String username);

    @Delete("truncate table us_history")
    void deleteAll();


}
